SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:IN THE VILLAGE OF CORNISH FLAT! THIS IS A SPACIOUS FARMHOUSE WITH A COMBINATION OF THE OLD CHARACTER AND THE CONVENIENCE OF THE NEW! WAIT UNTIL YOU SEE THIS INCREDIBLE BRAND NEW DREAM KITCHEN. IT WAS DESIGNED FOR A CHEF WITH ITS QUARTZ COUNTER TOPS, WALK-IN PANTRY, PORCELAIN FLOOR WITH RADIANT HEAT AND LOTS OF MODERN CONVENIENCES. THE RADIANT HEAT IS ALSO IN THE PANTRY AND MUDROOM FLOORS AS WELL AS THE NEW HALF BATH ON THE FIRST FLOOR. THE ATTACHED BARN HAS BEEN NEWLY CONVERTED TO A 2 CAR GARAGE WITH FULL STAIRS TO THE ABOVE STORAGE AREA. THE 7 ROOM FLOOR PLAN CAN BE FLEXIBLE DEPENDING ON YOUR NEEDS. THE LARGE LEVEL LOT HAS A LARGE GARDEN AREA WITH RICH GROWING SOIL AND EVEN INCLUDES THE CHICKEN COOP. THE METAL STANDING SEAM ROOF IS ALSO A BONUS TO APPRECIATE. THESE SELLERS HAVE GIVEN THIS SPECIAL HOME A NEW FACE-LIFT, BUT HAVE LEFT SOME ROOM FOR THE NEW OWNERS TO DO THE FINISHING TOUCHES. THIS IS A SPECIAL HOME IN THE VERY SPECIAL CORNISH COMMUNITY AND FOR THE HIGH SCHOOLERS, YOU EVEN HAVE A CHOICE OF HIGH SCHOOLS. COME QUICK....OR IT WILL BE GONE.
Description:This charming Bungalow has a large fenced in yard space and is close to all the amenities that Lebanon has to offer! First floor offers open Kitchen dining area with newer appliances and a walk in closet/pantry. Also a bedroom and full bath on the first level. Warm up with the pellet stove that sits on a brick hearth in the living room. Upstairs is the laundry area, a half bath and 2 additional bedrooms. There is a newer heating furnace plus the pellet stove. Lovely front enclosed porch. Corner lot, paved driveway and a detached 2 car garage. In town living with a great yard. Convenient to DHMC, shopping and more. Vacant and easy to show.
Description:Charming Home with Endless Potential – 9 Minutes to Dartmouth Hitchcock Medical Center! Discover this gem of a family home that’s brimming with possibilities. With its unbeatable location just 9 minutes from Dartmouth Hitchcock Medical Center and 11 minutes from Dartmouth College, this property offers both convenience and opportunity. The home features numerous upgrades, including, a cozy wood-burning fireplace in the living room, newer architectural shingled roof for worry-free living, replaced Harvey vinyl windows for energy efficiency. one-car garage for added convenience. The flexible floor plan includes Three spacious bedrooms, a large living room, dining room, kitchen and bathroom, a three season porch for relaxing year-round, basement workspace ideal for hobbies or storage, backyard deck overlooking a lush, private yard framed by mature hedges, additional highlights include a shed for extra storage and a recent exterior cleaning of the cedar shakes ensuring the home shines. For nature lovers the property is just 0.2 miles from the Northern Rail Trail and Mascoma River, offering endless outdoor recreation opportunities. While all the major updates are done, a little paint and creativity can transform this charming property into your dream home. Schedule your showing today and imagine the possibilities. Convenient, customizable, and perfectly located this home is waiting for your finishing touches.
Description:Large Lebanon house located in the business district. Commercial zoning. 3-4 bedrooms, 2 baths with a full walk out basement and 1 car garage. Spacious rooms, first floor laundry and the enclosed side porch is a nice feature. The yard has lilacs and a few trees that make it feel a bit more private, while still in the middle of town. Walk the rail trail that is located across the street. Convenient to most everything.
Description:Step inside through the marble checkered entry tile and take in the vaulted ceilings, creating an airy, open ambiance. The main living spaces feature gleaming cherry hardwood floors, warm wood paneling, interesting architectural design and enough space to gather and host. For the culinary enthusiast, the kitchen has a beautiful wide high-end Sub-Zero refrigerator, Wolf propane range, and ample counter space. There is a laundry room/mudroom off the kitchen and an ensuite bedroom off the living room perfectly suited for single level living. Upstairs, you'll find two more generous bedrooms with a jack-and-jill bathroom, a walk in cedar closet, and shelves for all your books, decor, and craft supplies. Above the attached two car garage you'll find a bonus area, perfect for finishing into a home office, gym, or extra living space. The garage already has a propane Rinnai heater. There is a private drilled well with reverse osmosis system for crisp water, and the house has a whole house Kohler generator that jumps right into action if needed. There is a wonderful deck with additional screened in porch that is quiet and ready for you to bring a book and enjoy the nature surrounding the property. With all the right bones in place, this property is ready to be transformed into your perfect oasis. Don't miss the chance to make this home yours in the sought-after Eastman community with tennis, skiing, trails and more.